Release 10.1A: OpenEdge Data Management:
SQL Reference
ROLLBACK
Ends the current transaction and undoes any database changes performed during the transaction.
Syntax
Notes
- Under certain circumstances, SQL marks a transaction for abort but does not actually roll it back immediately. Without an explicit
ROLLBACK, any subsequent updates do not take effect. ACOMMITstatement causes SQL to recognize the transaction as marked for abort and instead implicitly rolls back the transaction.- SQL marks a transaction for abort in the event of a hardware or software system failure. This transaction is rolled back during recovery.
Authorization
None
Related statements
COMMIT
|
Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |